package com.itheima.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.domain.combat.Soul;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface SoulMapper extends BaseMapper<Soul> {
    //根据分数查询灵魂
    @Select("SELECT * FROM tb_soul WHERE #{score} BETWEEN min_score AND max_score;")
    Soul findSoulByScore(@Param("score") Integer score);
}
